package ru.vsu.cs.kis.elections.server.db;

public class DBSchema {

	public static final String DB_TABLE = "kis";
	
	/** Table candidate */
	public static final String DB_TABLE_CANDIDATE = "candidate";
			
	public static final String DBT_CANDIDATE_FIO = "fio";
	
	public static final String DBT_CANDIDATE_ID = "id_cand";

	/** Table precinct */
	public static final String DB_TABLE_PRECINCT = "precinct";
			
	public static final String DBT_PRECINCT_ADDRESS = "address";
	
	public static final String DBT_PRECINCT_ID = "id_prec";
	
	public static final String DBT_PRECINCT_PASSWORD = "password";

	public static final String DBT_PRECINCT_STATE = "state";
	
	/** Table votes */
	public static final String DB_TABLE_VOTES = "votes";
			
	public static final String DBT_VOTES_PREC = "id_prec";
	
	public static final String DBT_VOTES_CAND = "id_cand";
	
	public static final String DBT_VOTES_COUNT = "votes";
	
	//TODO what is about session time and votes_id ???
}
